package shopping.dao;

import shopping.bean.Clothes;

import java.util.List;

public interface ClothesDao {
//    添加图书
    public int addClothes(Clothes clothes);
//    删除图书---根据id删除
    public int deleteClothesById(Integer id);
//    修改图书
    public int updateClothes(Clothes clothes);
//    查询图书---根据id查询
    public Clothes queryClothesById(Integer id);
//    查询所有图书
    public List<Clothes> queryClothess();

    Integer queryForPageTotalCount();

    List<Clothes> queryForPageItems(int begin, int pageSize);

    Integer queryForPageTotalCountByPrice(int min, int max);

    List<Clothes> queryForPageItemsByPrice(int begin, int pageSize, int min, int max);

    Integer queryForPageTotalCountByName(String name);

    List<Clothes> queryForPageItemsByName(int begin, int pageSize, String name);

    Integer queryForPageTotalCountByKind(String kind);

    List<Clothes> queryForPageItemsByKind(int begin, int pageSize, String kind);

    Clothes queryClothesByName(String name);
}
